SQL Tutorial Home

How to Remove a Default Value From a Column

To remove a default value in a table use the drop default clause:

alter table employee alter column last_bonus drop default;